CREATE TABLE "iws_freeze"
(
    "id"               VARCHAR(50) PRIMARY KEY,
    "task_id"          VARCHAR(50) NULL DEFAULT NULL,
    "floor"            VARCHAR(50) NULL DEFAULT NULL,
    "task_start"       VARCHAR(50) NULL DEFAULT NULL,
    "task_end"         VARCHAR(50) NULL DEFAULT NULL,
    "container_status" INT         NULL DEFAULT NULL,
    "container_code"   VARCHAR(50) NULL DEFAULT NULL,
    "status"           INT         NULL DEFAULT NULL,
    "work_ip"          VARCHAR(50) NULL DEFAULT NULL,
    "good_type"        VARCHAR(50) NULL DEFAULT NULL,
    "freeze_time"      DATETIME    NULL DEFAULT NULL,
    "freeze_name"      VARCHAR(50) NULL DEFAULT NULL,
    "freeze_des"       VARCHAR(50) NULL DEFAULT NULL,
    "freeze_notes"     VARCHAR(50) NULL DEFAULT NULL,

);
exec sp_addextendedproperty 'MS_Description', N'主键id', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'任务ID', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'task_id'
go
exec sp_addextendedproperty 'MS_Description', N'楼层', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'floor'
go
exec sp_addextendedproperty 'MS_Description', N'任务开始', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'task_start'
go
exec sp_addextendedproperty 'MS_Description', N'任务结束', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'task_end'
go
exec sp_addextendedproperty 'MS_Description', N'载具状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'container_status'
go
exec sp_addextendedproperty 'MS_Description', N'载具码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'container_code'
go
exec sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'status'
go
exec sp_addextendedproperty 'MS_Description', N'工位IP', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'work_ip'
go
exec sp_addextendedproperty 'MS_Description', N'货位类型', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'good_type'
go
exec sp_addextendedproperty 'MS_Description', N'冻结时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'freeze_time'
go
exec sp_addextendedproperty 'MS_Description', N'冻结账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'freeze_name'
go
exec sp_addextendedproperty 'MS_Description', N'冻结描述', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'freeze_des'
go
exec sp_addextendedproperty 'MS_Description', N'冻结信息', 'SCHEMA', 'dbo',
     'TABLE', 'iws_freeze', 'COLUMN', 'freeze_notes'
go
